123456/PO PHP H5/Ifra - Nisrine/filmdetails.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <link rel="stylesheet" href="style/style.css"> </head> <body> <div class="menubalk"> <a border="10" href="studio.php">studio's</a> <a href="film.php">films</a> <a href="characters.php">characters</a> <a href="personen.php">personen</a> </div> <?php include("db.php"); $flid = $_GET['filmid']; $query = "select * from films where filmid=$flid"; $result = mysqli_query($db, $query); $row = mysqli_fetch_array($result); echo "<h1>$row[titel]</h1>"; echo "<div><p> het is uigebracht in het jaar $row[release_date]</p></div>"; echo "<p>genre: $row[genre]</p>"; $query= "select * from films f, characters c where c.filmid=f.filmid and f.filmid=$flid"; $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)){ echo "<p>characters in $row[titel]</p>"; echo "<div><a href='characterdetails.php?characterid=$row[characterid]'>$row[naam_character]</a></div>"; } $query= "select * from films f, acteurs a where a.persoonid = f.persoonid and f.filmid=$flid"; $result = mysqli_query($db, $query); while ($row = mysqli_fetch_array($result)){ echo "<p>regisseur:</p> <a href='regiseurdetails.php?persoonid=$row[persoonid]'>$row[voornaam] $row[achternaam]</a>"; } $query = "select * from studio u, films f where f.studioid = u.studioid and f.filmid = $flid"; $result = mysqli_query($db, $query); $row = mysqli_fetch_array($result); echo "<div><p>gemaakst door studio</p></div>"; echo "<div><a href='studiodetails.php?studioid=$row[studioid]'>$row[naam]</a></div>"; ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse